7 replies to this topic

[Rinpyon]

Dear WP

would you please fix or do something about this...

we need shopping board to function well ^-^

 

+1

[Darurisey]

Things in this game are so poorly coded I swear to god

[SaltySailor]

Things in this game are so poorly coded I swear to god

 

It's not even their code. Pretty sure they got it off some random guy.

I agree with OP. They already have a 1 query per interaction limit, I don't see why showing all results would be that bad. Is the database server that bad that it can't execute basic searches?

[rdoc3]

It's not even their code. Pretty sure they got it off some random guy.

I agree with OP. They already have a 1 query per interaction limit, I don't see why showing all results would be that bad. Is the database server that bad that it can't execute basic searches?

When you make it "partial search", database cannot use indexes, because it uses "LIKE" where clause with "%" wt both ends.

Basicaly, database cannot use the index on the table and it needs to do a table scan, consuming processing time or even the machine disk reads, depending how sql server memory aloc is configured. now imagine hundreds of people quering at same time.

There are some features like full text search (its a service from mssql) that can be used, idk why is not used.

In other words:

Try to find on a dictionary all words with "ap" in the middle of the word and tell me how much time u took.

However, if you try to find all words starting with "ap" you can use the dictionary index and find it really fast, right?

Thats it.

[Chorvaqueen]

how do i even search for a slotted cap [1] when cap is too short

[SaltySailor]

When you make it "partial search", database cannot use indexes, because it uses "LIKE" where clause with "%" wt both ends.

Basicaly, database cannot use the index on the table and it needs to do a table scan, consuming processing time or even the machine disk reads, depending how sql server memory aloc is configured. now imagine hundreds of people quering at same time.

There are some features like full text search (its a service from mssql) that can be used, idk why is not used.

In other words:

Try to find on a dictionary all words with "ap" in the middle of the word and tell me how much time u took.

However, if you try to find all words starting with "ap" you can use the dictionary index and find it really fast, right?

Thats it.

 

Does it respect quotes for limiters? I use SQL all of the time, but idk what I can and can't do with their system.
 

[MihMaeBanares]

Dear WP

would you please fix or do something about this...

we need shopping board to function well ^-^

 

+1

 

+1 to this...

Hopefully they could fix and or atleast improve the search function of it.

[scraps345]

how do i even search for a slotted cap [1] when cap is too short

Easy actually, Just don't click partial and type in Cap.