Posts: 640
Activity: 126 (Full Member)
Potential Activity: 126 (Potential Full Member)
Post Quality: Excellent (90.00%)
Trust: Neutral
Estimated Price: 0.03969000

Starting:0.015
Increase:0.001
Buy:0.028

How much it would be? I want the background to be white and all containers will be green and button too

Hi currently I am new in VPS so dont know anything yet I just bought it with free cpanel and I want to configure it.
I will be paying 250k satoshis

Things needed

Upgrade php 5.5 to 5.6
Increase import limit in mysql to alteast 120mb

I want to host my website using vps but dont know how that works I just really need a simple file manager and database management to host my files and database with this requirements

Requirements

● PHP 5.6+ with crypt_blowfish and GD Library with freetype support enabled
● MySQL version 4.0+ Database
● 10+ MB Free Space
● FTP Access
● Write/Read Access (CHMOD777/755)
● Apache Server with mod_rewrite enabled

I need someone who can cache my query in my url shortener site. and how much it should be.


Full details

Hi it is a url shortener and my hosting said this my developer is a little bit busy so I need to fix this as soon as possible


My hosting said

However, we see another 'slow' query, which
takes about a second
to complete and downloads the whole 'views' table
from the database for
some reason, with all the rows:

select * from views

It gets about half a million records, nearly every
second, and that
affects your site's performance negatively.

Also, it is
highly recommended to
use some caching in your script, and cache the
database query result,
rather than send the same 'slow' query frequently.

my developers review

Using * is always a problem. Bcoz by using * you are
actually giving MySQL work to find all tables first and
then take the data. Instead of this best is .. If you want
every table then better write SELECT
rowname,rowname1,rowname2 FROM views

So I am running hitleap to other member on the other forum and it seems that He will cancel the contract after 30 days.
I am looking for someone who can provide me at least 2 hitleap in 2 vps that will run my account to farm minutes in 30 days 24 hours.
How much it should be?

Selling my account
Posts : 587
Activity : 98
Rank : Member
Potential Rank: Full member
Trust : Neutral
Signature Campaign: YES Yobit Signature
Price : 0.02
min. increment : 0.002
bin: 0.03

So my hosting says I need to fix this issue to optimize my sites performance

​Here is the join query which causes significant performance issues and should be optimized or re-written and split into few simple queries:

​select *, count(distinct views.views_id) as ViewCount from campaigns left join views ON views.views_campaign_id = campaigns.campaigns_id left join rates on rates.rates_id = campaigns.campaigns_rates_id where campaigns.campaigns_budget_used_today < campaigns.campaigns_daily_budget and campaigns.campaigns_current_budget > 0 and campaigns.campaigns_approved = 1 and campaigns.campaigns_status = 0 and campaigns.campaigns_payment_accepted = 1 and campaigns_device = 1 or campaigns.campaigns_device = 0 and rates_location = '' or rates.rates_location IS NULL group by campaigns.campaigns_daily_budget having ViewCount <= campaigns.campaigns_ordered_views * 1000 order by campaigns.campaigns_daily_budget asc

​It is a complex query with joins, which does not use indexes for some of the used columns. As the result, MySQL server creates temporary tables, performs scan of lots of table rows, and takes seconds to complete, which is not normal.

We have added indexes to the tables and columns used in the query​.​ However it can not fix the issue completely, and the query still takes a few seconds. The solution would be to rewrite the query, or replace it with a few simple select queries which use indexes.

Pm me if you can fix it.and how much

Bitcoin is use by at least 5% of the world as a payment method

I am thinking of if bitcoin used by the whole world 100% as a payment system what would be the price of bitcoin?

So my site is handling more visitors and my hosting says I need to fix something on script.

Hi,
You need to fix your script and optimize it for the
speed, which includes
changes to the database queries, better handling of
errors and delays
during HTTP requests made by the script to other sites
etc. That is the
only way to fix performance problems at your site.
Thanks,
Mike

at finixed nila ung ibqng sira ng site ko

Hi,
We have added some indexes to your database tables.
As the result, the
mentioned query now takes about 2 seconds to
complete. That is still too
long for a query, but much better than it was before.
You should see some
loading speed improvement, hopefully. Further
optimization can only be done
by fixing the script and rewriting MySQL queries (using
complex joins is
not recommended).
Thanks,
Jaroslav

I am paying $10 yun lng kc kaya ko sana may mktulong.

Hi po sabi ng hosting ko ay pwede na po akong lumipat sa vps para mkya ung load ng site ko pero wala po akong  alam na  vps na  may pre installed  na sftp at phpmyadmin pahelp nman po para sa mga nkkalam ung cpanel kc may license pa cya kya d kya  ng budget ko.

Hello from Bitlend.io,
When we launched Bitlend.io last year we vowed to
make it a unique platform within the cryptocurrency
industry. As many of us involved in the crypto industry
know, it can change overnight, and in some cases
within hours.
Taking into consideration several market factors and
other internal analysis we have decided to suspend
Bitlend.io’s operations for the foreseeable future.
New registrations have been suspended and all
verifications will be closed out. All Personally
Identifiable Information (PII) will be secured and/or
destroyed following the shutdown to protect the
documents and trust that our verified borrowers
placed with us.
What this means for you:
*All Users:*​ Do not deposit any further BTC into your
Bitlend.io wallet.
*Users with funds in their balance:*​ You will need to
withdraw them immediately. Please note that during the
wind down phase we will be manually processing all
transactions so they may take additional time to
complete.
*Borrowers with funded and active loans:*​ Your loans
are still in effect and the repayment schedule and
amount remains unchanged.
*Borrowers without active or funded loans:*​ No action
is required beyond withdrawing any balance you may
have on the system. Open loan requests will
automatically expire and close.
We would again like to thank everybody who joined us
at Bitlend.io for their support and business. We hope
to see all of you again in the future.
If you have any questions please contact
support@bitlend.io .
Regards,
The Bitlend.io Team

Hi po kailangan ko po ng immediate fund meron po akong 618 sakto lang po cya para sa fee ng mlhuilier d ko po cya naiwithdraw knina dhil d ko nman cya need pero ngayon need ko na po escrow is accepted.

Hi I want to buy Faucetbox template specifically a cheap template but good looking.

I want the design to be white background and green buttons that linked to different pages of the site.
and a pop up box when I click the claim button to get the reward.
or let me say after filing the captcha I will click on claim button then a pop up box will appear and theres an adspace there and a claim button again to claim the price.

just put your price and demo of the template.

I need this to buy a domain name but luck of funds in my paypal I will pay 50k satoshi or can be higher

I think no one is interested so I will close this thread

Hi ginawa ko ang thread na ito for personal only kc madalas may nagpapapalit sakin ng Paypal to Bitcoin at para sa mga trusted na members papatrade sana ako 3% to 10% ung fee ok lang.

[LIKE MY POST? CONSIDER DONATION:)]

First of all ang software na ito ay libre kong nakuha kaya bawal itong ibenta.

Some requirements.
Android Phone(2.3 to 4.4)
TalknText or Smart Sim card
3G Signal to 3.5G Preferred.
Konting knowledge sa pagedit.

Ang trick na ito ay para lang sa mga BitcoinTalk members at hindi pwedeng ilabas at ikalat dahil tayo din ang mawawalan kapag nadetect ni SMARTY.



Download this software
http://taffixbits.xyz/opera_mini_7.5.4_dzebb_handlerui_android.zip

Steps:
Install the software,after installing it open na natin at itype ang password




Iedit ang Primary at secondary Server



Backquery naman



Remove port,Proxy type at Proxy Server,uncheck Child Lock



List of Settings Copy lang po.

Password: www.nextwap.net

Settings

Opera mini settings.

Primary server:
global-4-cust-lvs-colossus.opera-mini.net

Global Server:
global-4-cust-lvs-colossus.opera-mini.net

Back Query:
http://mini5resource.opera-mini.net

Remove Port: Check

Proxy Type:
HTTP

Proxy Server:
mini5-1.opera-mini.net

Child Lock: Uncheck it


Internet Settings

Sa name at APN po ay kahit ano









At proof na working

LIKE MY POST? CONSIDER DONATION:)
38SSicLEht2iUeaN73ADaNZftUgq8kqgET

hi kakalog in ko lng sa cldmine ko mejo nkalimutan ko na kc at nkita ko lng ung advertisement nila kaya vinisit ko ulit at nakita ko ung bagong feature nea ma auto reinvest after 3 minutes cguro mas ok to sakin kc d ko macyadong navivisit ung site at may 400 doge na ako at 100% auto reinvest.

bali ineedit ko ung design nea haha.
pareview naman guys wala pa cyang balance

http://krisbits.ml/

itutuloy ko kung mganda ung review neu

sa mga faucet owners jan na mgccmula palang tulungan ko kayo

Hi ano po ung best coin to trade for now na meron kayo gusto ko sana subukan ang trading. Sa YOBIT PO